SELECT top 100
A.AddressNumber as [Vendor ID Number],
	A.TaxID as [TaxID],
	A.SearchType,
	A.AlphaName as [Vendor Name],
	B.AddressLine2 as [Vendor Address for Line1],
	B.AddressLine3 as [Vendor Address for Line1],
	A.*
	
FROM 
		dbo.JDEABAddressBookMaster A,
		dbo.[JDEABAddressBookAddressByDate] B
		
Where
	SearchTypeCode in ('V', 'XV')	and
	A.AddressNumber=B.AddressNumber

go

--select Distinct(searchType) from JDEABAddressBookMaster




/**
select top 100
* 
from dbo.JDEAPSupplierMaster
where AddressNumber>611500
go

**/
